﻿if exists (select * from dbo.sysobjects where name = 'sp_tblOrder_Update')
	drop procedure [dbo].[sp_tblOrder_Update]
Go 
CREATE PROCEDURE dbo.sp_tblOrder_Update
@_oid	int,
@_uid	int,
@_sid	int,
@_ocreatedate	datetime,
@_ostatus	smallint
AS
UPDATE tblOrder SET [_uid] = @_uid,[_sid] = @_sid,[_ocreatedate] = @_ocreatedate,[_ostatus] = @_ostatus
WHERE  _oid= @_oid
Go